package com.woniuxy.edubureau.dao;

import com.woniuxy.commons.entity.AnswerSheet;
import com.woniuxy.commons.entity.ScoreLine;
import com.woniuxy.commons.entity.TestPaper;
import com.woniuxy.commons.entity.wyh.GradeInfo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @author: luojiwei
 * @date: 2020/7/20 10:58
 * @description: 数据统计
 */
@Mapper
public interface StatisticsMapper {
    //根据学期、考试时间得到试卷信息
    public List<Long> getTestPaper(Long paperTerm,String startDate,String endDate);
    //根据试卷id、年级，答题卡信息
    public List<AnswerSheet> getAnswerSheet(String sheetGrade,long sheetPaperId);
    //根据学号查询成绩
    public List<Double> getScore(long sheetStudentNo);
    //根据年份查询分数线
    public ScoreLine getScoreLine(String year);
    //获取年级信息
    public List<GradeInfo> getGradeInfos();
}
